CREATE TABLE [dbo].[JOL_BulletinEmploymentLecture]
(
[JOL_BulletinLecture_No] [int] NOT NULL IDENTITY(1, 1),
[JOL_BulletinLecture_Title] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_BulletinLecture_Speaker] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_BulletinLecture_Time] [datetime] NULL,
[JOL_BulletinLecture_Position] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_BulletinLecture_Host] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_BulletinLecture_Organizer] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_BulletinLecture_Body] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[JOL_BulletinLecture_Remark] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[JOL_BulletinLecture_AddTime] [datetime] NULL,
[JOL_BulletinLecture_AddUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_BulletinLecture_UpdateTime] [datetime] NULL,
[JOL_BulletinLecture_UpdateUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_BulletinLecture_ClickNumber] [int] NULL,
[JOL_BulletinLecture_IsSetTop] [bit] NULL CONSTRAINT [DF__JOL_Bulle__JOL_B__62EF9734] DEFAULT ((0))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[JOL_BulletinEmploymentLecture] ADD CONSTRAINT [PK__JOL_BulletinEmpl__61FB72FB] PRIMARY KEY CLUSTERED  ([JOL_BulletinLecture_No]) ON [PRIMARY]
GO
